package org.jeecg.glr.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Transient;
import java.io.Serializable;
import java.util.Date;

/**
 * @Description: 根据路灯网关传输过来的数据计算后的统计数据
 * @Author: jeecg-boot
 * @Date:   2020-03-12
 * @Version: V1.0
 */
@Data
@TableName("glr_light_data")
public class GlrLightData implements Serializable {
    private static final long serialVersionUID = 1L;
    
	/**主键*/
	@TableId(type = IdType.UUID)
    private String id;
	/**路灯编号*/
	@Excel(name = "路灯编号", width = 15)
    private String ligCode;
	/**网关编号*/
	@Excel(name = "网关编号", width = 15)
    private String gataWayCode;

	@Excel(name = "平均电压")
	private Double avgVol;

	@Excel(name = "最小电压")
	private Double minVol;

	@Excel(name = "最大电压")
	private Double maxVol;

	@Excel(name = "平均电流")
	private Double avgCur;

	@Excel(name = "最小电流")
	private Double minCur;

	@Excel(name = "最大电流")
	private Double maxCur;

	@Excel(name = "平均温度")
	private Double avgTemperature;

	@Excel(name = "平均亮度")
	private Double avgBrightness;

	@Excel(name = "最小亮度")
	private Double minBrightness;

	@Excel(name = "最大亮度")
	private Double maxBrightness;

	@Excel(name = "平均功率")
	private Double avgPower;

	@Excel(name = "最小功率")
	private Double minPower;

	@Excel(name = "最大功率")
	private Double maxPower;

	@Excel(name = "当日用电量(KWH)")
	private Double dayElectricity;

	@Excel(name = "当日节约电量(KWH)")
	private Double dayEconomyElectricity;

	@Excel(name = "当月用电量(KWH)")
	private Double monthElectricity;

	@Excel(name = "当月节约电量(KWH)")
	private Double monthEconomyElectricity;

	@Excel(name = "当年用电量(KWH)")
	private Double yearElectricity;

	@Excel(name = "当年节约电量(KWH)")
	private Double yearEconomyElectricity;

	/**创建人*/
	@Excel(name = "创建人", width = 15)
    private String createBy;
	/**创建日期*/
	@Excel(name = "创建日期", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date createTime;
	/**更新人*/
	@Excel(name = "更新人", width = 15)
    private String updateBy;
	/**更新日期*/
	@Excel(name = "更新日期", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date updateTime;
	/**所属部门*/
	@Excel(name = "所属部门", width = 15)
    private String sysOrgCode;
	/**所属公司*/
	@Excel(name = "所属公司", width = 15)
    private String sysCompanyCode;



	@Transient private transient String dateTime;
	@Transient private transient String dateTimeYear;
	@Transient private transient String dateTimeMonth;
	/** 网关名称*/
	@Transient private transient String gataWayName;
}
